<?php 

class Module_Admin_Grid_User_Adapter extends Engine_Db_Adapter {
	
	protected function init(){
		$query = "SELECT
         u.id as id,
		 u.login,
		 CONCAT( u.firstName , ' ' , u.lastName) as name,
		 r.role
		 FROM user u
		 LEFT JOIN role r ON r.id = u.role";
		$this->setQuery($query);
	}

}